﻿--ApplicationSerialNumber-----------------
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ApplicationSerialNumber]'))
DROP TABLE [ApplicationSerialNumber]
GO
CREATE TABLE [ApplicationSerialNumber](
	[Key] [uniqueidentifier] NOT NULL DEFAULT NEWID(),
	[ApplicationName] [nvarchar](MAX) NOT NULL,
	[ApplicationVersion] [nvarchar](20) NULL,
	[Description] [nvarchar](200) NULL,
	[CreatedStamp] [datetime] NOT NULL,
	[LastUpdatedStamp] [datetime] NOT NULL,
 CONSTRAINT [PK_ApplicationSerialNumber] PRIMARY KEY CLUSTERED ([Key] ASC)) ON [PRIMARY]
GO
